package com.fan.dao.bill;

import com.fan.pojo.Bill;
import com.fan.pojo.Provider;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface BillDao {
    public int getBillCount(Connection connection, String productName, int providerId, int isPayment) throws SQLException;
    public List<Bill> getBillList(Connection connection, String productName, int providerId, int isPayment, int currentPageNo, int pageSize) throws SQLException;
    public int addBill(Connection connection, Bill bill) throws SQLException;
    public int deleteBillById(Connection connection, Integer delId) throws SQLException;
    public Bill getBillById(Connection connection, String id) throws SQLException;
    public boolean updateBillById(Connection connection,String id, String billCode, String productName, String productDesc, String productUnit, String productCount, String totalPrice, String isPayment, String providerId) throws SQLException;
}
